UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gVYJ0T5Er3YLyXt5d6NbxjJ6OQKBBKRbhtyTCVtl7fs='
WHERE
key_id = '3afbbdf3ffedeb9678d15cbc75cffd7cc875a0a78480e3fcb1636a5a5b0c3dba'
AND (
token = 'gVYJ0T5Er3YLyXt5d6NbxjJ6OQKBBKRbhtyTCVtl7fs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)