UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nVPTBylshlYZL0lC+0NH8qqrzBUEgRowozOHE0IAE6A='
WHERE
key_id = '4a7348b9fcaa3a67baee3e81e838126a1636ed37024485a51118ed11807df540'
AND (
token = 'nVPTBylshlYZL0lC+0NH8qqrzBUEgRowozOHE0IAE6A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)