UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PnY32HbB77ZUUocozaPjKzctgjbCjX5or34uR0Gxc4c='
WHERE
key_id = '5a686ddb3bd4d1bf778ef2ea463862320bbce3083f5eb46868123d1ac1c83df5'
AND (
token = 'PnY32HbB77ZUUocozaPjKzctgjbCjX5or34uR0Gxc4c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)