UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P+0XvebCuoIcHg7Gy04nz8lBwekqGYaI31u23q+4ehs='
WHERE
key_id = '77a51ca061f6c5994b07d8bc813cb8545b78dbcc3711854435dbe64257b77607'
AND (
token = 'P+0XvebCuoIcHg7Gy04nz8lBwekqGYaI31u23q+4ehs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)