UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZpDqMP0Zu430hglWD3D6mopD7b0VncUJjVYiQ2nUp34='
WHERE
key_id = '583cedcd5a9d3732b2c3cde6ab24b669f1f8cc143f397597216491f27d5dfc56'
AND (
token = 'ZpDqMP0Zu430hglWD3D6mopD7b0VncUJjVYiQ2nUp34='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)