UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iPSoDD9jGPrRPk1YWiVumpcu1FV+9HmzjdGqS71J3WI='
WHERE
key_id = 'f47a9f61a7c09fefbfe653c2aca26d68bd159604607e84ea08d82dbf89d489fc'
AND (
token = 'iPSoDD9jGPrRPk1YWiVumpcu1FV+9HmzjdGqS71J3WI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)