UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rnjledER9SSpxtZEQJaZiz2ZDw3KPCJsjSD3TPkM2Do='
WHERE
key_id = '56702973e306a225020668db9e76d686548dd6571839bf1a1a5d434f75015d6a'
AND (
token = 'rnjledER9SSpxtZEQJaZiz2ZDw3KPCJsjSD3TPkM2Do='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)