UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1tQRhMH8I4S0/Nz1FtPU6K3XjW5wZU6YCnbrwF4YXyM='
WHERE
key_id = 'a9babd8ad65afb73dfc7d8732c5148b6a515596cb4cd41b10b39605ffa46140e'
AND (
token = '1tQRhMH8I4S0/Nz1FtPU6K3XjW5wZU6YCnbrwF4YXyM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)