UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zpTtWIV1qqCzqUpC8PEGX/gJccoQ1FXu8SRtYotBC1Y='
WHERE
key_id = '9e9b1a1284a329d5623acbcfb6e234ea9efba1469ab7371f3fe3864896da1792'
AND (
token = 'zpTtWIV1qqCzqUpC8PEGX/gJccoQ1FXu8SRtYotBC1Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)