UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/oMsYExyrpLdrSjnPGw+VcCR1vIWkbpTf+vHnJktvrI='
WHERE
key_id = 'b4afd8e2d44cb778069e57e2e16aa6e866dfb04225334dca24b1d80215c93423'
AND (
token = '/oMsYExyrpLdrSjnPGw+VcCR1vIWkbpTf+vHnJktvrI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)