UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z1ZnGWfkmy4z5h1IWL71Xd2Ud3whpI5HQmtsgSbNl+E='
WHERE
key_id = '4308a7116c257dbafae57a42e31a8e816bc16d7f4762e495c278fa45cbf6115d'
AND (
token = 'z1ZnGWfkmy4z5h1IWL71Xd2Ud3whpI5HQmtsgSbNl+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)