UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aTpa6dpwRs0aN8U1M+igpVBzzpyhGE4q9nWX47hZFpo='
WHERE
key_id = '3c925d4ae131f0ed764d098b8ca36951c43034edff7ac68a620627ce1b27372a'
AND (
token = 'aTpa6dpwRs0aN8U1M+igpVBzzpyhGE4q9nWX47hZFpo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)