UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZXu3bjmtn4ClRSU3qtyivtxQZFLqceANZsP0mN+iJCY='
WHERE
key_id = 'a1f8319c91a91a6a55ba3bcd02b098299ef0dc5a357137074271d87fd1917679'
AND (
token = 'ZXu3bjmtn4ClRSU3qtyivtxQZFLqceANZsP0mN+iJCY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)