UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZNqn1Cr/guLUoEqL9LeG+0KzoKwUUcPQkh5Hu1IjUps='
WHERE
key_id = 'cfc1b3d8fa0fafaa73c13e6811874ea6b6653048f83312fb13c9b0b71fe12c88'
AND (
token = 'ZNqn1Cr/guLUoEqL9LeG+0KzoKwUUcPQkh5Hu1IjUps='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)