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