UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zc1DnTDblE+UPG4pdtCZhXOx5PJVAEASB8BSoLnNpR8='
WHERE
key_id = 'd17c3f606f3c6cd7ce237b978d3da0315d825b56f8025da4e2c45016e5166c05'
AND (
token = 'zc1DnTDblE+UPG4pdtCZhXOx5PJVAEASB8BSoLnNpR8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)