UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5gZkIFVN46w9tC/ygjI5hoEf7A3vZNe0WBXXbQ75Mo8='
WHERE
key_id = '5f0fcb6d6ed68e432ed46a4e66409d772090958cae12216191812c3a8d0469ed'
AND (
token = '5gZkIFVN46w9tC/ygjI5hoEf7A3vZNe0WBXXbQ75Mo8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)