UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4Hyv3FzX9oZ8miEb6nMsHZO1U57m1CBA+JBrobsI0Pw='
WHERE
key_id = '5599897167df530d824a7d2f665264332aeba3b9c4af01dde7924aa99e8e0e4a'
AND (
token = '4Hyv3FzX9oZ8miEb6nMsHZO1U57m1CBA+JBrobsI0Pw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)