UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Rii6o8KYAD9syTSKL7fbWNeFsYvVMSHExSGOaoRJKJE='
WHERE
key_id = '06cdec6336c92697d0e59f41020d32b68e5908d7b5c2fdec9338ac34a941ccac'
AND (
token = 'Rii6o8KYAD9syTSKL7fbWNeFsYvVMSHExSGOaoRJKJE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)