UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G6lomoGmsQeJKVZH2mLqYXvxNY87dDW7nfNJfptH62M='
WHERE
key_id = '26d34b93158e55b9dc0ffa27f0c11979548a0c774e61cf43351a67712b7fff79'
AND (
token = 'G6lomoGmsQeJKVZH2mLqYXvxNY87dDW7nfNJfptH62M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)