UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7DOOX/7mGJ07ibGIn6nPjne/tpByOv4lEOauwD+qVSc='
WHERE
key_id = '7718b585147731fbc2cde46fd5a19ba689efb45014ad153c8658116df3fad394'
AND (
token = '7DOOX/7mGJ07ibGIn6nPjne/tpByOv4lEOauwD+qVSc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)