UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2bz4akl+uRhnETpOfNME8i7LHEcHJVwJ7s1bV44EtME='
WHERE
key_id = 'c2ef74d3695e8cbc8088d6b3005dc11d3bc8c26ccd9d78f6a4bc0044efcd9301'
AND (
token = '2bz4akl+uRhnETpOfNME8i7LHEcHJVwJ7s1bV44EtME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)