UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VmktCkD/UFRtlySZTSk+N8EgEmAGxjs1PpnlGD0ncPg='
WHERE
key_id = 'a27f861a0baca0f63187b95259c712ca7c8c2a47cfeeff032fef14ae1c71036a'
AND (
token = 'VmktCkD/UFRtlySZTSk+N8EgEmAGxjs1PpnlGD0ncPg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)