UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LCLNWUtrYsWBs98yCGCNIKEe0WlZjpgfbHZoYFdlbzU='
WHERE
key_id = '8df45c8a5deefde87b89dc9aaf230b286517682ca801e8118ad8c38538c92a3e'
AND (
token = 'LCLNWUtrYsWBs98yCGCNIKEe0WlZjpgfbHZoYFdlbzU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)