UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/j44imxR41MdY0j4FdEKhFFnjHk40UiSIovvaU6eNXs='
WHERE
key_id = 'd2a31ebd5157f0d1e21acf5a6e5991fc2b64e1e9c46397dfc8594a3120a25f89'
AND (
token = '/j44imxR41MdY0j4FdEKhFFnjHk40UiSIovvaU6eNXs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)