UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'btthxH2Lec8tjkB2QuhnSYdsuFwxRTniVVlmpHUxGzA='
WHERE
key_id = 'd2e2006a7550dd553384527fea0671592240a87d51c5a8fc1c1d241cefeb3dbc'
AND (
token = 'btthxH2Lec8tjkB2QuhnSYdsuFwxRTniVVlmpHUxGzA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)