UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8zRxg8a/NQjINNsM5O+RNYCzMyVwbYbg76SoA1d+mRk='
WHERE
key_id = 'f3257ae6c19832d887d5224953c7a85d15acf2525a648a25b5f4b6bb88792518'
AND (
token = '8zRxg8a/NQjINNsM5O+RNYCzMyVwbYbg76SoA1d+mRk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)