UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oWnJIEFma7SNee1dSZPqbqkK1I1fgt6Y9ThI3IcsWLA='
WHERE
key_id = 'eb71edf51d0995ec6fc5e2f97db408d80df76304fe7890341ade6e4387f9b52e'
AND (
token = 'oWnJIEFma7SNee1dSZPqbqkK1I1fgt6Y9ThI3IcsWLA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)