UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kcFcaXRocS4HfnuyedC99ZLGUzANpx0sB2RqHiM9dEA='
WHERE
key_id = '0bfd872300ce9ac624ac754c5873b7dfc80171265f09bcaac9d3900c924ea8fa'
AND (
token = 'kcFcaXRocS4HfnuyedC99ZLGUzANpx0sB2RqHiM9dEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)