UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NwJcVc4aANKpi8n7Ae5j5QTTvpKrm0KMUF2ak/KUIPw='
WHERE
key_id = 'efb050c028d1da7518eee1cfc53ce7bb82f0e3c630f889b534fc94153b35212a'
AND (
token = 'NwJcVc4aANKpi8n7Ae5j5QTTvpKrm0KMUF2ak/KUIPw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)