UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AD5yHIxNV6Az64LL5f1H5nHPuraaFjizvPoLHnPJUEw='
WHERE
key_id = '29f26047f71299d4fb33a9aeaf42e787489f354a4ee3c8d4b9128437b6d9ca02'
AND (
token = 'AD5yHIxNV6Az64LL5f1H5nHPuraaFjizvPoLHnPJUEw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)