UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9gVVObz0z1C4Uq7qz0B3QrbAUQ7kLyYDlJktb/sgIxA='
WHERE
key_id = '236a4c775fdf7dbed06835eac211e8465629b2511d98caa131b6870ad3bda27d'
AND (
token = '9gVVObz0z1C4Uq7qz0B3QrbAUQ7kLyYDlJktb/sgIxA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)