UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gJ0mnfSdGio66qI1t5glvMFtgMdvnT1MCAb85D+X2GI='
WHERE
key_id = 'fc78140a478607fb5cf32034e743988436bbbd061508605815ad8f8b65d6bb63'
AND (
token = 'gJ0mnfSdGio66qI1t5glvMFtgMdvnT1MCAb85D+X2GI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)