UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DiSZ8Kg16kMaecXS+tBQUUBGD5xX5jiZgRYULz1/xr0='
WHERE
key_id = 'b7c9ef616258605771de4f8fee630d8d792998e253e14ca5ef19b2fea04cbe2e'
AND (
token = 'DiSZ8Kg16kMaecXS+tBQUUBGD5xX5jiZgRYULz1/xr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)